package com.example.mapper;

import com.example.pojo.*;
import org.apache.ibatis.annotations.Mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

/**
 * 描述
 *
 * @Author xulitao
 * @Date 2022/3/12
 * @Version 1.0
 */
@Mapper
public interface CountChartDao {
    List<CountChartEntity> getScoreByStu();

    List<CountChartEntity> getScoreByTeacher();

    List<CountChartEntity> getScoreByClass();

    List<AskNumEntity> getPlayNum();

    List<WorkNumEntity> getFinishStuNum();

    List<WorkNumEntity> getFinishTeacherNum();

    Map<String, Object> getScoreCountByzz(Long currentUserId);

    Map<String, Object> getScoreCountByzx(Long currentUserId);

    List<Map<String, Object>> getInteractiveCountByb();

    List<Map<String, Object>> getInteractiveCountByz();


    List<Map<String, Object>> getJobCountByr();

    List<Map<String, Object>> getJobCountBys();

    List<JobTableEntity> getJobCountByrName(Long currentUserId);

    List<String> getJobCountByrScore();


    List<String> queryMaxScore();

    List<String> queryMinScore();

    List<IndexChartEntity> queryMaxAndMin(Long userId);

    Map<String, Object> getScoreCountBt(Long currentUserId);

    List<BigDecimal> getScoreCountSdt(Long currentUserId);

    List<Map<String, Object>> getScoreCountLdt(Long currentUserId);

    List<BigDecimal> getScoreCountByzzAvg(Long currentUserId);
}
